/*
 Navicat Premium Data Transfer

 Source Server         : ShortLink
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : 182.92.243.232:3306
 Source Schema         : shortlink

 Target Server Type    : MySQL
 Target Server Version : 80023
 File Encoding         : 65001

 Date: 10/06/2021 09:22:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for url_logging
-- ----------------------------
DROP TABLE IF EXISTS `url_logging`;
CREATE TABLE `url_logging` (
  `id` int NOT NULL AUTO_INCREMENT,
  `short_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `region` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `isp` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `device_class` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `device_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `agent_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `timestamp` datetime NOT NULL,
  `origin_ua` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `origin_ip_information` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of url_logging
-- ----------------------------
BEGIN;
INSERT INTO `url_logging` VALUES (1, 'htBEh', NULL, '华北', '中国', '山西', '晋中', '电信', 'PC', NULL, 'Chrome', '2021-06-09 18:54:12', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"ab6876b94c604b1598def9ddeab1111c\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"993030030\",\"city\":\"晋中\",\"ip\":\"59.48.111.142\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140700\"}}');
INSERT INTO `url_logging` VALUES (3, '4TjRA0', NULL, '华南', '中国', '广东', '深圳', '联通', 'iPhone', 'Apple iPhone', 'QQ Client', '2021-06-09 18:57:32', 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_3_4 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Mobile/13G35 QQ/6.5.3.410 V1_IPH_SQ_6.5.3_1_APP_A Pixel/750 Core/UIWebView NetType/2G Mem/117', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"259a08aacc664f9e86f923c385b205cc\",\"data\":{\"area\":\"华南\",\"country\":\"中国\",\"long_ip\":\"989559226\",\"city\":\"深圳\",\"ip\":\"58.251.121.186\",\"isp\":\"联通\",\"region_id\":\"440000\",\"region\":\"广东\",\"country_id\":\"CN\",\"city_id\":\"440300\"}}');
INSERT INTO `url_logging` VALUES (5, '4TjRA0', NULL, '', '美国', '', '', '', 'PC', NULL, 'Chrome', '2021-06-09 18:57:32', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"2c6f3ec7055e424ca7fad73410e0fc46\",\"data\":{\"area\":\"\",\"country\":\"美国\",\"long_ip\":\"165292876\",\"city\":\"\",\"ip\":\"9.218.43.76\",\"isp\":\"\",\"region_id\":\"\",\"region\":\"\",\"country_id\":\"US\",\"city_id\":\"\"}}');
INSERT INTO `url_logging` VALUES (7, '4TjRA0', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 18:57:50', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"3625e3c453614227afb6404945921049\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (9, '4TjRA0', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 18:58:04', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 PA QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"77b2929ec051469ba8f00f3cfeba43a8\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (11, '4TjRA0', NULL, '华北', '中国', '山西', '太原', '电信', '11', 'Apple iPhone', 'QQ Client', '2021-06-09 18:58:15', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/18F72 QQ/8.8.0.608 V1_IPH_SQ_8.8.0_1_APP_A Pixel/828 MiniAppEnable SimpleUISwitch/0 StudyMode/0 QQTheme/1000 Core/WKWebView Device/Apple(iPhone 11) NetType/4G QBWebViewType/1 WKType/1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"98502e0521df4cd7b154cb50c6211a8b\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (13, '4TjRA0', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 18:58:16', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 PA QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"702755dae1d247c99b136f96f7648634\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (15, '4TjRA0', NULL, '华北', '中国', '山西', '太原', '电信', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 18:58:34', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.6(0x18000632) NetType/4G Language/zh_CN', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"91a7242ab2ac4a3abdd45750634d68c3\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (17, '4TjRA0', NULL, '华东', '中国', '江苏', '南京', '电信', 'PC', NULL, 'Chrome', '2021-06-09 18:58:34', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"4bf239ccefbf451f90034c31413179df\",\"data\":{\"area\":\"华东\",\"country\":\"中国\",\"long_ip\":\"3026286303\",\"city\":\"南京\",\"ip\":\"180.97.118.223\",\"isp\":\"电信\",\"region_id\":\"320000\",\"region\":\"江苏\",\"country_id\":\"CN\",\"city_id\":\"320100\"}}');
INSERT INTO `url_logging` VALUES (19, '4TjRA0', NULL, '华北', '中国', '山西', '太原', '电信', 'iPhone', 'Apple iPhone', 'Safari', '2021-06-09 18:59:09', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.1.1 Mobile/15E148 Safari/604.1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"40e54a3f0c474e01bf1c6e1d1e008707\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (21, '4TjRA0', NULL, '华东', '中国', '上海', '上海', '电信', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 18:59:33', 'Mozilla/5.0 (iPhone; CPU iPhone OS 10_2_1 like Mac OS X) AppleWebKit/602.4.6 (KHTML, like Gecko) Mobile/14D27 MicroMessenger/6.5.5 NetType/WIFI Language/en', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"7075320ef1814d06ae6c43524fe6e707\",\"data\":{\"area\":\"华东\",\"country\":\"中国\",\"long_ip\":\"1700478553\",\"city\":\"上海\",\"ip\":\"101.91.62.89\",\"isp\":\"电信\",\"region_id\":\"310000\",\"region\":\"上海\",\"country_id\":\"CN\",\"city_id\":\"310100\"}}');
INSERT INTO `url_logging` VALUES (23, '4TjRA0', NULL, '华北', '中国', '山西', '晋中', '电信', 'PC', NULL, 'Chrome', '2021-06-09 19:07:43', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"101a47e55ffb435ebe1df83abd77ffd6\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"993030030\",\"city\":\"晋中\",\"ip\":\"59.48.111.142\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140700\"}}');
INSERT INTO `url_logging` VALUES (25, '3jH0oP', NULL, '华北', '中国', '山西', '晋中', '电信', 'PC', NULL, 'Chrome', '2021-06-09 19:07:55', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"a929334d24bc4cd494917151929f3482\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"993030030\",\"city\":\"晋中\",\"ip\":\"59.48.111.142\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140700\"}}');
INSERT INTO `url_logging` VALUES (27, 'wFOBQ', NULL, '华北', '中国', '山西', '太原', '电信', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:10:06', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.6(0x18000632) NetType/4G Language/zh_CN', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"32d713031808492fac1119fa07d4bb97\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (29, 'wFOBQ', NULL, '华北', '中国', '山西', '太原', '电信', '11', 'Apple iPhone', 'QQ Client', '2021-06-09 19:10:42', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/18F72 QQ/8.8.0.608 V1_IPH_SQ_8.8.0_1_APP_A Pixel/828 MiniAppEnable SimpleUISwitch/0 StudyMode/0 QQTheme/1000 Core/WKWebView Device/Apple(iPhone 11) NetType/4G QBWebViewType/1 WKType/1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"726f7e05bd024e51aedf705f0abf325f\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (31, 'wFOBQ', NULL, '华东', '中国', '上海', '上海', '电信', 'Android', 'Smartisan SM801', 'WeChat', '2021-06-09 19:11:06', 'Mozilla/5.0 (Linux; Android 5.1.1; SM801 Build/LMY47V; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/53.0.2785.49 Mobile MQQBrowser/6.2 TBS/043024 Safari/537.36 MicroMessenger/6.5.4.1000 NetType/4G Language/zh_CN', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"a5dd1b9e0b2c4c24a6f86c4b9bbef0c8\",\"data\":{\"area\":\"华东\",\"country\":\"中国\",\"long_ip\":\"1700339022\",\"city\":\"上海\",\"ip\":\"101.89.29.78\",\"isp\":\"电信\",\"region_id\":\"310000\",\"region\":\"上海\",\"country_id\":\"CN\",\"city_id\":\"310100\"}}');
INSERT INTO `url_logging` VALUES (33, '4Vr1vC', NULL, '', '美国', '', '', '', 'PC', NULL, 'Chrome', '2021-06-09 19:17:08', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"65367f243aed486281359372aefab268\",\"data\":{\"area\":\"\",\"country\":\"美国\",\"long_ip\":\"165293014\",\"city\":\"\",\"ip\":\"9.218.43.214\",\"isp\":\"\",\"region_id\":\"\",\"region\":\"\",\"country_id\":\"US\",\"city_id\":\"\"}}');
INSERT INTO `url_logging` VALUES (35, '4Vr1vC', NULL, '华北', '中国', '山西', '太原', '电信', '11', 'Apple iPhone', 'QQ Client', '2021-06-09 19:17:13', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/18F72 QQ/8.8.0.608 V1_IPH_SQ_8.8.0_1_APP_A Pixel/828 MiniAppEnable SimpleUISwitch/0 StudyMode/0 QQTheme/1000 Core/WKWebView Device/Apple(iPhone 11) NetType/4G QBWebViewType/1 WKType/1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"e4f2b9f3bf064d89867962134834f54b\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (37, '4Vr1vC', NULL, '华北', '中国', '山西', '晋中', '电信', 'PC', NULL, 'Chrome', '2021-06-09 19:17:25', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"c39c2d14d1be4e75aec009d499e9dd7f\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"993030030\",\"city\":\"晋中\",\"ip\":\"59.48.111.142\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140700\"}}');
INSERT INTO `url_logging` VALUES (39, '4Vr1vC', NULL, '华北', '中国', '山西', '太原', '电信', '11', 'Apple iPhone', 'QQ Client', '2021-06-09 19:17:31', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/18F72 QQ/8.8.0.608 V1_IPH_SQ_8.8.0_1_APP_A Pixel/828 MiniAppEnable SimpleUISwitch/0 StudyMode/0 QQTheme/1000 Core/WKWebView Device/Apple(iPhone 11) NetType/4G QBWebViewType/1 WKType/1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"a2e879ecdf224626a744731cc27945c0\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (41, '4Vr1vC', NULL, '华北', '中国', '山西', '太原', '电信', 'iPhone', 'Apple iPhone', 'Safari', '2021-06-09 19:17:51', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.1.1 Mobile/15E148 Safari/604.1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"2526a4d3af904025985851dd9ed7c848\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (43, 'wFOBQ', NULL, '华北', '中国', '山西', '晋中', '电信', 'PC', NULL, 'Chrome', '2021-06-09 19:19:26', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"4d14044fd1d34f40a3d159152f899aed\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"993030030\",\"city\":\"晋中\",\"ip\":\"59.48.111.142\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140700\"}}');
INSERT INTO `url_logging` VALUES (45, '4TjRA0', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 19:21:32', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"82511609200e4a6f99c9586f5739ad33\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (47, '4Vr1vC', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 19:21:54', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"56b8a42fcd844fc1b59ef5b9e477d9e5\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (49, '4Vr1vC', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 19:22:02', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"c6edcad0d1b442e6998829dc3901f360\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (51, '4Vr1vC', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 19:22:15', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"a5940328333944a187351a375a0dc826\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (53, '4Vr1vC', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 19:22:26', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"8be398a5f798456d982b9245e1fd7643\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (55, '4Vr1vC', NULL, '华北', '中国', '山西', '太原', '电信', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:23:05', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.6(0x18000632) NetType/4G Language/zh_CN', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"9d0053a2bae0467d86452a75aaafba99\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (57, '4Vr1vC', NULL, '华北', '中国', '天津', '天津', '移动', 'Android', 'Huawei YAL-AL00', 'WeChat', '2021-06-09 19:23:25', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045617 Mobile Safari/537.36 MMWEBID/6213 MicroMessenger/8.0.6.1900(0x28000637) Process/tools WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"84f779f7bd07495bad89b3677f800f1e\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1864465930\",\"city\":\"天津\",\"ip\":\"111.33.126.10\",\"isp\":\"移动\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (59, '4Vr1vC', NULL, '华东', '中国', '上海', '上海', '电信', 'Android', 'Smartisan SM801', 'WeChat', '2021-06-09 19:24:06', 'Mozilla/5.0 (Linux; Android 5.1.1; SM801 Build/LMY47V; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/53.0.2785.49 Mobile MQQBrowser/6.2 TBS/043024 Safari/537.36 MicroMessenger/6.5.4.1000 NetType/4G Language/zh_CN', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"f912d2486d9444edb5f658a050730822\",\"data\":{\"area\":\"华东\",\"country\":\"中国\",\"long_ip\":\"1033351857\",\"city\":\"上海\",\"ip\":\"61.151.178.177\",\"isp\":\"电信\",\"region_id\":\"310000\",\"region\":\"上海\",\"country_id\":\"CN\",\"city_id\":\"310100\"}}');
INSERT INTO `url_logging` VALUES (61, '4Vr1vC', NULL, '华北', '中国', '天津', '天津', '移动', 'Android', 'Huawei YAL-AL00', 'WeChat', '2021-06-09 19:24:11', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045617 Mobile Safari/537.36 MMWEBID/6213 MicroMessenger/8.0.6.1900(0x28000637) Process/tools WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"8682dfda8cd14ebf8b88484b0776c1d4\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1864465930\",\"city\":\"天津\",\"ip\":\"111.33.126.10\",\"isp\":\"移动\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (63, '3O3uBn', NULL, '', '美国', '', '', '', 'PC', NULL, 'Chrome', '2021-06-09 19:24:48', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"2a7d5422fd62459392111624c4bc572e\",\"data\":{\"area\":\"\",\"country\":\"美国\",\"long_ip\":\"165293024\",\"city\":\"\",\"ip\":\"9.218.43.224\",\"isp\":\"\",\"region_id\":\"\",\"region\":\"\",\"country_id\":\"US\",\"city_id\":\"\"}}');
INSERT INTO `url_logging` VALUES (65, '3O3uBn', NULL, '华北', '中国', '山西', '太原', '电信', '11', 'Apple iPhone', 'QQ Client', '2021-06-09 19:24:52', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/18F72 QQ/8.8.0.608 V1_IPH_SQ_8.8.0_1_APP_A Pixel/828 MiniAppEnable SimpleUISwitch/0 StudyMode/0 QQTheme/1000 Core/WKWebView Device/Apple(iPhone 11) NetType/4G QBWebViewType/1 WKType/1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"85a7a8c317c946bf88ef273696cb8a37\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (67, '3O3uBn', NULL, '华北', '中国', '天津', '天津', '联通', 'Android', 'Huawei YAL-AL00', 'QQ Client', '2021-06-09 19:24:55', 'Mozilla/5.0 (Linux; Android 10; YAL-AL00 Build/HUAWEIYAL-AL00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045618 Mobile Safari/537.36 V1_AND_SQ_8.8.0_1792_YYB_D A_8080010 QQ/8.8.0.5420 NetType/WIFI WebP/0.3.0 Pixel/1080 StatusBarHeight/108 SimpleUISwitch/0 QQTheme/1000 InMagicWin/0 StudyMode/0', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"4baab337b8984208970833356b671c25\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1872787168\",\"city\":\"天津\",\"ip\":\"111.160.118.224\",\"isp\":\"联通\",\"region_id\":\"120000\",\"region\":\"天津\",\"country_id\":\"CN\",\"city_id\":\"120100\"}}');
INSERT INTO `url_logging` VALUES (69, '3O3uBn', NULL, '华北', '中国', '山西', '太原', '电信', '11', 'Apple iPhone', 'QQ Client', '2021-06-09 19:25:30', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/18F72 QQ/8.8.0.608 V1_IPH_SQ_8.8.0_1_APP_A Pixel/828 MiniAppEnable SimpleUISwitch/0 StudyMode/0 QQTheme/1000 Core/WKWebView Device/Apple(iPhone 11) NetType/4G QBWebViewType/1 WKType/1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"012189fa3bc54192beb263c56353669b\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (71, '3O3uBn', NULL, '华东', '中国', '上海', '上海', '电信', 'PC', NULL, 'Chrome', '2021-06-09 19:25:48', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"3aa41b52cf764c7db68ca765161203a3\",\"data\":{\"area\":\"华东\",\"country\":\"中国\",\"long_ip\":\"1033359309\",\"city\":\"上海\",\"ip\":\"61.151.207.205\",\"isp\":\"电信\",\"region_id\":\"310000\",\"region\":\"上海\",\"country_id\":\"CN\",\"city_id\":\"310100\"}}');
INSERT INTO `url_logging` VALUES (73, '3O3uBn', NULL, '华北', '中国', '山西', '太原', '电信', '11', 'Apple iPhone', 'QQ Client', '2021-06-09 19:29:28', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/18F72 QQ/8.8.0.608 V1_IPH_SQ_8.8.0_1_APP_A Pixel/828 MiniAppEnable SimpleUISwitch/0 StudyMode/0 QQTheme/1000 Core/WKWebView Device/Apple(iPhone 11) NetType/4G QBWebViewType/1 WKType/1', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"b57fbd7efb8849abaf9718544643a79f\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (75, '3O3uBn', NULL, '华东', '中国', '上海', '上海', '电信', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:29:41', 'Mozilla/5.0 (iPhone; CPU iPhone OS 8_3 like Mac OS X) AppleWebKit/600.1.4 (KHTML; like Gecko) Mobile/12F70 MicroMessenger/6.1.5 NetType/WIFI', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"737f4b442c8f4eb1ab44eb07f4065a29\",\"data\":{\"area\":\"华东\",\"country\":\"中国\",\"long_ip\":\"1033359217\",\"city\":\"上海\",\"ip\":\"61.151.207.113\",\"isp\":\"电信\",\"region_id\":\"310000\",\"region\":\"上海\",\"country_id\":\"CN\",\"city_id\":\"310100\"}}');
INSERT INTO `url_logging` VALUES (77, '3O3uBn', NULL, '', '美国', '', '', '', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:29:42', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/7.0.12(0x17000c2f) NetType/4G Language/zh_CN wechatdevtools', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"454233b0f4ba4ee3a619bbc067065877\",\"data\":{\"area\":\"\",\"country\":\"美国\",\"long_ip\":\"196770098\",\"city\":\"\",\"ip\":\"11.186.121.50\",\"isp\":\"\",\"region_id\":\"\",\"region\":\"\",\"country_id\":\"US\",\"city_id\":\"\"}}');
INSERT INTO `url_logging` VALUES (79, '3O3uBn', NULL, '华东', '中国', '上海', '上海', '电信', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:30:05', 'Mozilla/5.0 (iPhone; CPU iPhone OS 8_3 like Mac OS X) AppleWebKit/600.1.4 (KHTML; like Gecko) Mobile/12F70 MicroMessenger/6.1.5 NetType/WIFI', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"7cbe8755b6b44f52b1b6c19a33dcf181\",\"data\":{\"area\":\"华东\",\"country\":\"中国\",\"long_ip\":\"1033358864\",\"city\":\"上海\",\"ip\":\"61.151.206.16\",\"isp\":\"电信\",\"region_id\":\"310000\",\"region\":\"上海\",\"country_id\":\"CN\",\"city_id\":\"310100\"}}');
INSERT INTO `url_logging` VALUES (81, '3O3uBn', NULL, '华东', '中国', '上海', '上海', '电信', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:30:23', 'Mozilla/5.0 (iPhone; CPU iPhone OS 8_3 like Mac OS X) AppleWebKit/600.1.4 (KHTML; like Gecko) Mobile/12F70 MicroMessenger/6.1.5 NetType/WIFI', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"7faa90a36cfa4687ab019487c276a231\",\"data\":{\"area\":\"华东\",\"country\":\"中国\",\"long_ip\":\"1033358864\",\"city\":\"上海\",\"ip\":\"61.151.206.16\",\"isp\":\"电信\",\"region_id\":\"310000\",\"region\":\"上海\",\"country_id\":\"CN\",\"city_id\":\"310100\"}}');
INSERT INTO `url_logging` VALUES (83, '3O3uBn', NULL, '华中', '中国', '湖南', '长沙', '联通', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:30:33', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.6(0x18000632) NetType/WIFI Language/zh_CN', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"5e251803abc24738a4b04f3d028106e6\",\"data\":{\"area\":\"华中\",\"country\":\"中国\",\"long_ip\":\"1849031998\",\"city\":\"长沙\",\"ip\":\"110.53.253.62\",\"isp\":\"联通\",\"region_id\":\"430000\",\"region\":\"湖南\",\"country_id\":\"CN\",\"city_id\":\"430100\"}}');
INSERT INTO `url_logging` VALUES (85, '3O3uBn', NULL, '华南', '中国', '广东', '广州', '移动', 'Android', 'Huawei ELS-AN00', 'WeChat', '2021-06-09 19:32:17', 'Mozilla/5.0 (Linux; Android 10; ELS-AN00 Build/HUAWEIELS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045617 Mobile Safari/537.36 MMWEBID/8389 MicroMessenger/8.0.3.1880(0x2800033F) Process/tools WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"10e6660b80044706a627a39dfff4c77d\",\"data\":{\"area\":\"华南\",\"country\":\"中国\",\"long_ip\":\"3748152155\",\"city\":\"广州\",\"ip\":\"223.104.67.91\",\"isp\":\"移动\",\"region_id\":\"440000\",\"region\":\"广东\",\"country_id\":\"CN\",\"city_id\":\"440100\"}}');
INSERT INTO `url_logging` VALUES (87, '3O3uBn', NULL, '华南', '中国', '广东', '广州', '移动', 'Android', 'Huawei ELS-AN00', 'WeChat', '2021-06-09 19:32:24', 'Mozilla/5.0 (Linux; Android 10; ELS-AN00 Build/HUAWEIELS-AN00; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045617 Mobile Safari/537.36 MMWEBID/8389 MicroMessenger/8.0.3.1880(0x2800033F) Process/tools WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"df9d2a83cafd499aa14c291077c7f2f9\",\"data\":{\"area\":\"华南\",\"country\":\"中国\",\"long_ip\":\"3748152155\",\"city\":\"广州\",\"ip\":\"223.104.67.91\",\"isp\":\"移动\",\"region_id\":\"440000\",\"region\":\"广东\",\"country_id\":\"CN\",\"city_id\":\"440100\"}}');
INSERT INTO `url_logging` VALUES (89, '3O3uBn', NULL, '华中', '中国', '湖南', '长沙', '联通', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:33:08', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.6(0x18000632) NetType/WIFI Language/zh_CN', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"80e56a14a12646cd8c478fc20cbabf8c\",\"data\":{\"area\":\"华中\",\"country\":\"中国\",\"long_ip\":\"1849031998\",\"city\":\"长沙\",\"ip\":\"110.53.253.62\",\"isp\":\"联通\",\"region_id\":\"430000\",\"region\":\"湖南\",\"country_id\":\"CN\",\"city_id\":\"430100\"}}');
INSERT INTO `url_logging` VALUES (91, '3O3uBn', NULL, '华北', '中国', '内蒙古', '包头', '联通', 'iPhone', 'Apple iPhone', 'WeChat', '2021-06-09 19:33:39', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 MicroMessenger/8.0.7(0x18000726) NetType/WIFI Language/zh_CN', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"23dff34152664a1dbded1ceb16a52f2c\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"18668395\",\"city\":\"包头\",\"ip\":\"1.28.219.107\",\"isp\":\"联通\",\"region_id\":\"150000\",\"region\":\"内蒙古\",\"country_id\":\"CN\",\"city_id\":\"150200\"}}');
INSERT INTO `url_logging` VALUES (93, '3O3uBn', NULL, '华北', '中国', '山西', '太原', '移动', 'Android', 'Vivo X21I A', 'WeChat', '2021-06-09 19:37:36', 'Mozilla/5.0 (Linux; Android 9; vivo X21i A Build/P00610; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.120 MQQBrowser/6.2 TBS/045617 Mobile Safari/537.36 MMWEBID/9901 MicroMessenger/8.0.6.1900(0x28000637) Process/tools WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"e4af78fbe4e34818829b94c28df8fa2e\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"1971848198\",\"city\":\"太原\",\"ip\":\"117.136.4.6\",\"isp\":\"移动\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (95, '3O3uBn', NULL, '华北', '中国', '内蒙古', '呼和浩特', '联通', 'Android', 'Xiaomi MI 10 PRO', 'WeChat', '2021-06-09 19:43:22', 'Mozilla/5.0 (Linux; Android 11; Mi 10 Pro Build/RKQ1.200826.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/78.0.3904.62 XWEB/2797 MMWEBSDK/20210501 Mobile Safari/537.36 MMWEBID/4928 MicroMessenger/8.0.6.1900(0x2800063B) Process/toolsmp WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"9da227e5900d4a889177f7fe06407978\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"3703787217\",\"city\":\"呼和浩特\",\"ip\":\"220.195.78.209\",\"isp\":\"联通\",\"region_id\":\"150000\",\"region\":\"内蒙古\",\"country_id\":\"CN\",\"city_id\":\"150100\"}}');
INSERT INTO `url_logging` VALUES (97, '3O3uBn', NULL, '华北', '中国', '内蒙古', '呼和浩特', '联通', 'Android', 'Xiaomi MI 10 PRO', 'WeChat', '2021-06-09 19:49:01', 'Mozilla/5.0 (Linux; Android 11; Mi 10 Pro Build/RKQ1.200826.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/78.0.3904.62 XWEB/2797 MMWEBSDK/20210501 Mobile Safari/537.36 MMWEBID/4928 MicroMessenger/8.0.6.1900(0x2800063B) Process/toolsmp WeChat/arm64 Weixin NetType/4G Language/zh_CN ABI/arm64', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"a8767d0d59384570a0257b0b1970f1ec\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"3703787217\",\"city\":\"呼和浩特\",\"ip\":\"220.195.78.209\",\"isp\":\"联通\",\"region_id\":\"150000\",\"region\":\"内蒙古\",\"country_id\":\"CN\",\"city_id\":\"150100\"}}');
INSERT INTO `url_logging` VALUES (99, '3O3uBn', '1.68.83.209', '华北', '中国', '山西', '太原', '电信', 'iPhone', 'Apple iPhone', 'Quark', '2021-06-09 20:01:51', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_6 like Mac OS X; zh-cn) AppleWebKit/601.1.46 (KHTML, like Gecko) Mobile/18F72 Quark/5.0.6.1199 Mobile', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"5a8a1b7c7045410ba40591882f13080a\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"21255121\",\"city\":\"太原\",\"ip\":\"1.68.83.209\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140100\"}}');
INSERT INTO `url_logging` VALUES (101, '3O3uBn', NULL, '华北', '中国', '山西', '晋中', '电信', 'PC', NULL, 'Chrome', '2021-06-09 20:07:51', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.87 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"090cf3319aa448ae9b8825205cba55fb\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"993030030\",\"city\":\"晋中\",\"ip\":\"59.48.111.142\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140700\"}}');
INSERT INTO `url_logging` VALUES (103, '3O3uBn', '59.48.111.142', '华北', '中国', '山西', '晋中', '电信', 'PC', NULL, 'Chrome', '2021-06-09 20:15:29', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"d8a3932f5203495595ccbf90adababa1\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"993030030\",\"city\":\"晋中\",\"ip\":\"59.48.111.142\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140700\"}}');
INSERT INTO `url_logging` VALUES (105, '3O3uBn', '59.48.111.142', '华北', '中国', '山西', '晋中', '电信', 'PC', NULL, 'Chrome', '2021-06-09 20:52:26', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36', '{\"ret\":200,\"msg\":\"success\",\"log_id\":\"d986ad6044c24190b158c37a43161bda\",\"data\":{\"area\":\"华北\",\"country\":\"中国\",\"long_ip\":\"993030030\",\"city\":\"晋中\",\"ip\":\"59.48.111.142\",\"isp\":\"电信\",\"region_id\":\"140000\",\"region\":\"山西\",\"country_id\":\"CN\",\"city_id\":\"140700\"}}');
COMMIT;

-- ----------------------------
-- Table structure for url_mapping
-- ----------------------------
DROP TABLE IF EXISTS `url_mapping`;
CREATE TABLE `url_mapping` (
  `id` int NOT NULL AUTO_INCREMENT,
  `short_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `former_url` varchar(9999) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=99487 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of url_mapping
-- ----------------------------
BEGIN;
INSERT INTO `url_mapping` VALUES (99459, '3FQlyC', 'http://wisdom.cisau.com.cn/wisdomprovider/router?method=wisdom.extra.activity.taskList&pageSize=10000&sign=49FADDED463D671FD25154314D72125C8A48AD61&startNum=0&tenantCode=sxxyzhxy&userId=6505b074-d077-4a50-963c-9eb1c232c813&v=2.0', '2021-06-07 22:21:58');
INSERT INTO `url_mapping` VALUES (99461, '2VQmY5', 'http://youxuechuang.chinaedu.net/wisdomprovider/router', '2021-06-07 22:28:17');
INSERT INTO `url_mapping` VALUES (99463, '2wDqan', 'http://youxuechuang.chinaedu.net/wisdomprovider/router?appKey=00000001&appType=1&format=json&method=wisdom.tenant.tenantList&sign=720C587E434A2BFF3F24A297CB4F4E373AE234A2&tenantCode=tskjxy&timestamp=1623076164&v=1.0', '2021-06-07 22:30:20');
INSERT INTO `url_mapping` VALUES (99465, '2lBe5l', 'http://wisdom.cisau.com.cn/wisdomprovider/router?appKey=00000001&appType=1&format=json&method=wisdom.index.list&sign=1BF53454007512701C7AD4D54AAFC2C792B59A9C&tenantCode=sxxyzhxy&timestamp=1623111108&userId=6505b074-d077-4a50-963c-9eb1c232c813&v=1.0', '2021-06-08 08:13:54');
INSERT INTO `url_mapping` VALUES (99467, '1ED6uB', 'http://wisdom.tskjxy.com.cn/wisdomprovider/router?appKey=00000001&appType=1&format=json&method=wisdom.index.list&sign=1BF53454007512701C7AD4D54AAFC2C792B59A9C&tenantCode=sxxyzhxy&timestamp=1623111108&userId=6505b074-d077-4a50-963c-9eb1c232c813&v=1.0', '2021-06-08 08:20:40');
INSERT INTO `url_mapping` VALUES (99469, '3lj2fr', 'https://www.aliyun.com/ss/aXDlnLDlnYA/a', '2021-06-09 17:03:57');
INSERT INTO `url_mapping` VALUES (99471, '29uwqi', 'https://www.csdn.net/tags/MtjaQg3sMTE5NzAtYmxvZwO0O0OO0O0O.html', '2021-06-09 17:18:27');
INSERT INTO `url_mapping` VALUES (99473, 'HT5q1', 'https://www.coder55.com/article/51101', '2021-06-09 17:19:11');
INSERT INTO `url_mapping` VALUES (99475, 'htBEh', 'https://www.baidu.com/s?wd=springboot%20%E8%8E%B7%E5%8F%96%E5%9F%9F%E5%90%8D&rsv_spt=1&rsv_iqid=0xf7684f0e00029956&issp=1&f=8&rsv_bp=1&rsv_idx=2&ie=utf-8&rqlang=cn&tn=baiduhome_pg&rsv_enter=1&rsv_dl=tb&oq=%25E5%2589%258D%25E7%25BC%2580&rsv_btype=t&inputT=5241&rsv_t=ed46ZgkjtBjoinygD4sBEFMBr6nt%2FIlntFj1HAZBq16FjceY50TXEkawll8DTU%2FK9Rq0&rsv_sug3=17&rsv_sug1=15&rsv_sug7=101&rsv_pq=c1b3fdcb0004bef4&rsv_sug2=0&rsv_sug4=6359', '2021-06-09 17:19:34');
INSERT INTO `url_mapping` VALUES (99477, '4TjRA0', 'https://detail.tmall.com/item.htm?id=539674395647&spm=a21bo.21814703.201876.29.5af911d9nSEedj&scm=1007.34127.227518.0&pvid=448e3951-c77c-414e-919b-d790a0652f3f', '2021-06-09 18:57:22');
INSERT INTO `url_mapping` VALUES (99479, '3jH0oP', 'https://www.bilibili.com/video/BV1j64y1o7ir?spm_id_from=333.851.b_7265636f6d6d656e64.4', '2021-06-09 19:07:53');
INSERT INTO `url_mapping` VALUES (99481, 'wFOBQ', 'https://try.yauaa.basjes.nl/', '2021-06-09 19:09:48');
INSERT INTO `url_mapping` VALUES (99483, '4Vr1vC', 'https://v.douyin.com/e92aeNA/', '2021-06-09 19:16:57');
INSERT INTO `url_mapping` VALUES (99485, '3O3uBn', 'https://www.bilibili.com/video/BV1ko4y117Ms?spm_id_from=333.851.b_7265636f6d6d656e64.2', '2021-06-09 19:24:44');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
